SHERBERT RESEARCH
1 Intoduction
Hello, I’m Joseph from Morocco.
Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.
I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.
Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.
This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.
2 About the project
The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.
The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.
3 EDA
3.1 market research indestry’s yearly new recruit count
3.2 sherbert research’s workforce status over the years
4 Workforce sample
4.1 Abby Jones
Job title: Director
Associated: False
Socials: https://linkedin.com/in/abby-jones-3a400510 | https://twitter.com/peopletr
4.1.1 Abby Jones’s working period at sherbert research
4.1.2 Gantt plot of Abby Jones’s experience
4.2 Bay Clark
Job title: Director
Associated: False
Socials: https://linkedin.com/in/bay-clark-a3751923
4.2.1 Bay Clark’s working period at sherbert research
4.2.2 Gantt plot of Bay Clark’s experience
4.3 Bob Popumoff
Job title: Knee slapper
Associated: True
Socials: https://linkedin.com/in/bob-popumoff-16a42019a
4.3.1 Bob Popumoff’s working period at sherbert research
4.3.2 Gantt plot of Bob Popumoff’s experience
4.4 Danielle Moore
Job title: Graduate intern
Associated: False
Socials: https://linkedin.com/in/danielle-moore-a1049b80
4.4.1 Danielle Moore’s working period at sherbert research
4.4.2 Gantt plot of Danielle Moore’s experience
4.5 Danielle Morris
Job title: Research assistant
Associated: False
Socials: https://linkedin.com/in/morrisdanielle | https://angel.co/danielle-morris | https://twitter.com/danisaidthis | https://linkedin.com/in/danielle-morris-7474b322
4.5.1 Danielle Morris’s working period at sherbert research
4.5.2 Gantt plot of Danielle Morris’s experience
4.6 Danielle Rodi
Job title: Graduate intern
Associated: False
Socials: https://linkedin.com/in/danielle-rodi-a1049b80
4.6.1 Danielle Rodi’s working period at sherbert research
4.6.2 Gantt plot of Danielle Rodi’s experience
4.7 Emma Worrollo
Job title: Associate director
Associated: False
Socials: https://linkedin.com/in/emmaworrollo
4.7.1 Emma Worrollo’s working period at sherbert research
4.7.2 Gantt plot of Emma Worrollo’s experience
4.8 Eyal Efrat
Job title: Finance and operations director
Associated: True
Socials: https://linkedin.com/in/eyal-efrat-8783441a
4.8.1 Eyal Efrat’s working period at sherbert research
4.8.2 Gantt plot of Eyal Efrat’s experience
4.9 Gemma Wise
Job title: Junior research executive
Associated: True
Socials: https://linkedin.com/in/gemma-wise-56a29b159
4.9.1 Gemma Wise’s working period at sherbert research
4.9.2 Gantt plot of Gemma Wise’s experience
4.10 Herbert Sherbert
Job title: Marketing director
Associated: True
Socials: https://linkedin.com/in/herbert-sherbert-8b1aa517
4.10.1 Herbert Sherbert’s working period at sherbert research
4.10.2 Gantt plot of Herbert Sherbert’s experience
4.11 Ioanna Mentzou
Job title: Project manager
Associated: False
Socials: https://linkedin.com/in/ioanna-mentzou-83a438 | https://twitter.com/imentzos
4.11.1 Ioanna Mentzou’s working period at sherbert research
4.11.2 Gantt plot of Ioanna Mentzou’s experience
4.12 Jonathan Lichtenfeld
Job title: Intern
Associated: False
Socials: https://linkedin.com/in/jonathanlichtenfeld | https://facebook.com/jonathan.lichtenfeld.3 | https://linkedin.com/in/jonathan-lichtenfeld-22b844b6
4.12.1 Jonathan Lichtenfeld’s working period at sherbert research
4.12.2 Gantt plot of Jonathan Lichtenfeld’s experience
4.13 Lucy Seager
Job title: Work experience at children’s market research agency
Associated: False
Socials: https://linkedin.com/in/lucy-seager-90464443
4.13.1 Lucy Seager’s working period at sherbert research
4.13.2 Gantt plot of Lucy Seager’s experience
4.14 Marnie Freeman
Job title: Director
Associated: True
Socials: https://linkedin.com/in/marnie-freeman-7884635
4.14.1 Marnie Freeman’s working period at sherbert research
4.14.2 Gantt plot of Marnie Freeman’s experience
4.15 Nicki Karet
Job title: Managing director
Associated: True
Socials: https://linkedin.com/in/nicki-karet-3113445 | https://twitter.com/nicki_sherbert
4.15.1 Nicki Karet’s working period at sherbert research
4.15.2 Gantt plot of Nicki Karet’s experience
4.16 Sarah Mann
Job title: Project manager and research co-ordinator
Associated: False
Socials: https://linkedin.com/in/sarah-mann-6a41a914